PostalCodeReference

Entity Definition

Logical Name : PostalCodeReference
Physical Name : LU_PSTL_CD_RFC

Identifies and defines all postal codes for given country. In the US this is ZIP CODE. This entity is intended to support a variety of postal code formats and value lists for countries that use them (which is US, Canada, Brazil, Western Europe, Japan, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PostalCodeID (PK) A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. ID_PSTL_CD Identity integer
PostalCode (AK) Postal code value. In ARTS this is an alphanumeric attribute because unlike the US other countries use letters in their postal codes. CD_PSTL Code varchar(20)
ISOCountryCode (AK)(FK) The ISO-3166-1 two letter code denoting a locality in which the retailer does business. CD_CY_ISO Code2 char(2) ISO3166-1Country(LO_CY_ISO)
PostalCodeDescription PostalCode name or descriptioin DE_PSTL_CD DescriptionShort varchar(255)
PostalCodeExtension (AK) This is a second tier postal code that qualifies the PostalCode attribute and allows more precise mail sorting. It does not apply to all countries' postal codes. Also, it is usually not mandatory. So it can be omitted for business purposes. For data integrity purposes this attribute will be assigned a default values of all zeros so it can be treated as part of an unique alternate key. CD_PSTL_EXTN Code4External char(4)

Relationships

Parent Entity Verb Phrase Child Entity
ISO3166-1Country authorizes PostalCodeReference
PostalCodeReference validates GeographicSegmentPostalCode
PostalCodeReference defines postal area for Address
PostalCodeReference defines postal area for KeyCustomerGeographicSegment

Logical Views containing PostalCodeReference

Logical View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View